/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 18:00:05
*/


-- ----------------------------
-- Table structure for tb0034
-- ----------------------------
DROP TABLE [dbo].[tb0034]
GO
CREATE TABLE [dbo].[tb0034] (
[ID] int IDENTITY(1,1) NOT NULL,
[BankAccountID] varchar(50) NOT NULL ,
[AccountID] varchar(20) NULL ,
[CurrencyID] varchar(20) NULL ,
[BankAccountNo] nvarchar(50) NULL ,
[BankName] nvarchar(250) NULL ,
[Notes] nvarchar(250) NULL ,
[Disabled] tinyint NOT NULL DEFAULT ((0)) ,
[OpenDate] datetime NULL ,
[CloseDate] datetime NULL ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL ,
[BankID] varchar(20) NULL ,
[GroupShow] varchar(300) NULL 
)


GO

-- ----------------------------
-- Records of tb0034
-- ----------------------------
INSERT INTO [dbo].[tb0034] ([BankAccountID], [AccountID], [CurrencyID], [BankAccountNo], [BankName], [Notes], [Disabled], [OpenDate], [CloseDate], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [BankID], [GroupShow]) VALUES (N'VCB CN', N'1121', N'VND', N'0061000366515', N'CONG THUONG HUYNH THI KIEU SUONG', N'TK CA NHAN', N'0', N'2013-07-17 00:00:00.000', N'2013-08-17 00:00:00.000', N'2013-08-17 15:05:31.463', N'TRANGNT', N'2013-08-17 15:05:31.463', N'TRANGNT', null, N'')
GO
GO
INSERT INTO [dbo].[tb0034] ([BankAccountID], [AccountID], [CurrencyID], [BankAccountNo], [BankName], [Notes], [Disabled], [OpenDate], [CloseDate], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [BankID], [GroupShow]) VALUES (N'ACB', N'1121', N'VND', N'52961089', N'AÙ CHAU', N'', N'0', N'2013-04-18 00:00:00.000', N'2013-04-18 00:00:00.000', N'2013-04-18 11:06:41.523', N'TRANGNT', N'2013-04-18 11:13:57.287', N'TRANGNT', null, N'')
GO
GO
INSERT INTO [dbo].[tb0034] ([BankAccountID], [AccountID], [CurrencyID], [BankAccountNo], [BankName], [Notes], [Disabled], [OpenDate], [CloseDate], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [BankID], [GroupShow]) VALUES (N'SCB', N'1121', N'VND', N'050005016905', N'THUONG TIN', N'', N'0', N'2013-04-18 00:00:00.000', N'2013-04-18 00:00:00.000', N'2013-04-18 11:11:20.653', N'TRANGNT', N'2013-04-18 11:11:20.653', N'TRANGNT', null, N'')
GO
GO
INSERT INTO [dbo].[tb0034] ([BankAccountID], [AccountID], [CurrencyID], [BankAccountNo], [BankName], [Notes], [Disabled], [OpenDate], [CloseDate], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [BankID], [GroupShow]) VALUES (N'BIDV', N'1121', N'VND', N'60110000207263', N'ÑAÀU TÖ VAØ PHAÙT TRIEÅN VIEÄT NAM', N'', N'0', N'2013-04-18 00:00:00.000', N'2013-04-18 00:00:00.000', N'2013-04-18 11:13:16.243', N'TRANGNT', N'2013-04-18 11:13:16.243', N'TRANGNT', null, N'')
GO
GO
INSERT INTO [dbo].[tb0034] ([BankAccountID], [AccountID], [CurrencyID], [BankAccountNo], [BankName], [Notes], [Disabled], [OpenDate], [CloseDate], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [BankID], [GroupShow]) VALUES (N'VCB', N'1121', N'VND', N'0061000343210', N'CONG THUONG', N'', N'0', N'2013-04-18 00:00:00.000', N'2013-04-18 00:00:00.000', N'2013-04-18 11:12:24.543', N'TRANGNT', N'2013-04-18 11:12:24.543', N'TRANGNT', null, N'')
GO
GO

-- ----------------------------
-- Indexes structure for table tb0034
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0034
-- ----------------------------
ALTER TABLE [dbo].[tb0034] ADD PRIMARY KEY NONCLUSTERED ([BankAccountID])
GO
